Hi, I have extracted the complete data but I need only the Yellow Marked Name how to use string operation to get this name only. I have extracted the completed text as shown in the image from “billed to” to “Po Number”.
StringVariable.split({Environment.newline},stringsplitoptions.removeemptyEntries)(1)
Just Play with the Index Value to get the desired Output.
1 Like
@Vijay_Tulsalkar Thnaks for the quick response. BTW I need only Cecilia Chapman.
hello @balkishan
you can split the string based on the Newline character (Environment.Newline)
then simply store the output of the split into a array(type string).
by using index you will get the exact Name.
@balkishan Her you go with xaml file
Split.xaml (4.8 KB)
Hi @balkishan,
If you know regular expressions also you can do it easily.
I have no idea about the regular expression.
Hi @balkishan,
Using regex we can get data easily.
Please find the reference for that using regular expressions
^C[a-z]+\s+C[a-z]*
To get the data - Cecilia Chapman
@varunk I want to get this address yellow colored marked. How can I do it. I don’t have idea about the regext. bcz I didn’t use regext.
Hi @balkishan,
Is that constant,can you share your input file
I can hep you
No it’s dynamic It’s changing on every new invoice bro
Hi @balkishan,
Can you share invoice