Text file output string manipulation

Hi See below text file output. How do i add a | delimeter between each word and then concatenate each word so it looks like this and then outputs it to a text file all on one line?

From:
"Yours faithfully,
Signature Signature
Date Date "

To:
“Yours faithfully|Signature|Signature|Date|Date”

Hi ,
you can refer thisquery

1 Like

Thank you. My big question now is how do i do it with a text files output that has alot more data like what you just did?

read the text file using the activity and then pass that variable inside the assign acitivity.

Hmmm ok. It seems to not like it. I am using your method. see below images.

image
image

can you send me that pdfextract text file

testoutput.zip (441 Bytes)

Please see attached. I really appreciate you help here

your text file already has “|”

Haha so sorry. The text file looks exactly like that but without the pipe symbol.

use a * after the \n and try

Hi @rohangroombridge,

I’m attaching a workflow. Hope you will find your solution.
Main.xaml (10.0 KB)

You just have to replace my text variable with your variable where you have stored your text.

Thanks & Regards,
Apurba

Perfect!!! Thank you so much!!!

Hi @rohangroombridge,

Always most welcome.

Thanks & Regards,
Apurba

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.