If condition for 3rd last character in string

[DML1]

I want to check if 3rd last character of a string is ,(comma) then replace with .(dot) otherwise it should be ,(comma).

Example: in 654.12,89 -  , and . has to be replaced only when prior to 89 is ,

If it's like this 654,12. 89 then no action required.

Pls guide

[ScottShearer]

@DML1 

See my example below - this is one way but there are others...

[DML1]

Thanks for your efforts to help me. Sorry to say the output is incorrect. Below should be the actual,

If Input = 654.12,89

Then Output = 654,12.89 ( condition should check for 3rd last character. we can't predict the # digits from the first, it should be dynamic)

If input = 654,12.89

Then output = 654,12.89 (No change because the 3rd last character is not ,)

In simple terms, if the string is European number format then convert that to normal number format if not then keep as it is.

Hope my question is clear.

Thank you once again.

[v-yujincui-msft]

Hi @DML1 ,

I have made a test for your reference. Maybe you could try as below:

substring(item()?['Value'],add(length(item()?['Value']),-3),1)

concat(replace(first(split(item()?['Value'],',')),'.',','),'.',last(split(item()?['Value'],',')))

item()?['Value']

Result Screenshot:

Best Regards,

Charlie Choi

[v-yujincui-msft]

Hi @DML1 ,

Is your problem solved?

Best Regards,

Charlie Choi

[DML1]

Hi Charlie,

Thanks for your efforts to help me. The problem solved using sub, length, substring and replace.

But it required 5 steps to reach the correct output, 15 steps I added for 3 fields of  Ai Builder( net amount, gross amount & tax amount)

Bit worrying it should impact the API limit, can I share the list of actions, could you pls guide me how to reduce the number of actions.

If yes I can share the images

Regards,

DML

[v-yujincui-msft]

Hi @DML1 ,

Yeah, you could share your Flow setup, maybe we could try it together. 

Best Regards,

Charlie Choi

[DML1]

Sure Charlie definitely will work together and solve this. Below are the expressions I used for gross amount, same way its for net and tax amount as well.

Gross Amount:

If(or(equals(outputs('Extract_information_from_invoices')?['body/response v2/predictionOutput/result/fields/invoiceTotal/valueText'],null),contains(outputs('Extract_information_from_invoices')?['body/response v2/predictionOutput/result/fields/invoiceTotal/valueText'],' '),contains(outputs('Extract_information_from_invoices')?['body/response v2/predictionOutput/result/fields/invoiceTotal/valueText'],'-')),(outputs('Extract_information_from_forms')?['body/response v2/predictionOutput/labels/Gross_Amount/value'],outputs('Extract_information_from_invoices')?['body/response v2/predictionOutput/result/fields/invoiceTotal/valueText'])

Gross Amount Currency - Compose:

If(or(contains(outputs('Gross_Amount'),'€'),contains(outputs('Gross_Amount'),'$'),contains(outputs('Gross_Amount'),' ')), replace(replace(replace (outputs('Gross_Amount'),'€', ''),'$',''),' ',''), outputs ('Gross_Amount'))

Gross Compose - SubL:

sub(length(outputs ('Gross_Amount_Currency_-_Compose')),4)

Gross Compose - Substring:

substring(outputs ('Gross_Amount_Currency_-_Compose'), outputs ('Gross_Compose_-_SubL'),4)

Compose - Gross:

if (and(contains (outputs ('Gross_Compose_-_SubString),','), contains (outputs ('Gross_Amount_Currency_-_Compose'),'.','x'),',','.'),'x',','), if(contains (outputs ('Gross_Compose_-_SubString),','), replace (outputs ('Gross_Amount_Currency_-_Compose'),',','.'),
outputs ('Gross_Amount_Currency_-_Compose')))

Regards,

DML

[v-yujincui-msft · Accepted solution]

Hi @DML1 ,

Thanks for such detailed information, maybe you could consider combining the third and fourth Action.

substring(outputs ('Gross_Amount_Currency_-_Compose'), sub(length(outputs ('Gross_Amount_Currency_-_Compose')),4),4)

Best Regards,

Charlie Choi