String manipulation - help required

[mesalcan (Marco Salazar)]

I have the following string:

“\n\t\t\t\t\t\t\tClient Information Details\n \n Client ID: RX80036\n Client Name: Nathan Jasik\n Client Country: Romania\n\t\t\t\t\t\t\t\t\n \n\t\t\t\t\t\t”

and in the need to get the:

Client ID,
Client Name, and
Client Country

any help would be highly appreciated

Thanks!

[sagacity (Scott Z.)]

Something like Replace(Replace($STRING,‘\t’,‘’),‘\n’,vbCrLf)) would give you:

Client Information Details

Client ID: RX80036
Client Name: Nathan Jasik
Client Country: Romania

[pattyricarte (Patty Boy)]

Hi @mesalcan,

Hope this might be helpful to you!

https://rpageek.com/uipath-string-manipulation/

cheers

Happy learning

[sagacity (Scott Z.)]

@pattyricarte Yeah - even better; that’s what it comes down to - being proficient in all the string manipulation tools.

[pattyricarte (Patty Boy)]

Hi @sagacity

That’s great i hope we solve t he problem

cheers

Happy learning

[mesalcan (Marco Salazar)]

I have tried this “Replace(Replace($STRING,’\t’,’’),’\n’,vbCrLf))” and I am getting the error “Expression expected”

Thanks!

[sagacity (Scott Z.)]

@mesalcan - Sorry. That was pseudo code meaning to give you an idea how to approach. The exact (except the input string, which you need to supply) would be:

inString.Replace("\t","").Replace("\n",vbnewline)

[mesalcan (Marco Salazar)]

@sagacity - Thanks, I was using vbCrLf instead of vbnewline. I am not getting the error anymore; but it is still not working as you can see:

Here is the value of ClientName

Thanks!

[AdarshSaxena]

Hello mesalcan,
Try This Solution. It will be quite easy:Main.xaml (8.0 KB)

Please let me know whether it works for you or not.

[mesalcan (Marco Salazar)]

Thanks, it worked, and I can see why.