String manipulation after get text action


#1

LP%20Nummer
LP%20Nummer%202

LP%20Nummer%203

Hey at all,

i have used get text Action to filter a specific text out of a PDF. All the PDFs have the same layout and i only would like to get the red framed number as you can see in the picures.

I store the Output of the get text Action in a value. Now i have the Problem that i don’t know how to manipulate this string, so that i only get the specific number.

Hope you guys having some ideas.
Thanks a lot.


#2

@tobschroer Split ur variable with respect to space(" "). Below command give u required output.

String var=Split(UrStringVariable," ")(1)


#3

Thanks @Manjuts90,

i will try. Where i have to type this in?
Sorry, i’m a totally beginner.
Thanks


#4

@tobschroer use below activity show in pic.

image

Create a new string variable in variable section. Use it on left side of assign activity.

On right side type Split(UrStringVariable," ")(1)


#5

Thanks @Manjuts90

I think something is still wrong.


#6

@tobschroer Instead of Urstringvariable give the variable name which u have given to output of gettext activity. If your not assigned any variable to output of gettext activity. Create a new string variable and assign that variable to output of gettext activity, use that variable in place of Urstringvariable


#7

i have got it :slight_smile:

thanks a lot @Manjuts90


#8

@tobschroer if u got answer close the thread by marking it as solution.


#9

sorry @Manjuts90,

just another quick question. I want to use this stored number and use it with the Basic recording, type Action. So how can i use my new variable therefore?

Thanks a lot


#10

@tobschroer u want use the final variable inside recording. Do recording normally. After recording replace what u have typed in type into activity with ur variable.


#11

Perfect, thanks.


#12

3021025.pdf (146.3 KB)
i need to get data from pdf
1.Date(2018/02/28)
2.QUANTITY (DIGITS)(1,000.000)
i used get text activity but i cant scrap it
so please i need a help
How to get those data


#13

@123 Please find the attachment for the solution xaml file.

pdf------.xaml (18.2 KB)


#14

Tq manjuts for your help


#15

BUT when i copied it and saved in main flow it is showing error
error:Disallow implicit conversation from string to char


#16

Actually i sent u pdf there are no of pdf will be come from share point we need to get some data from it and we need to populate in excel form Template.xlsx (15.4 KB)
3021025.pdf (146.3 KB)


#17

@123 what data u need other than date and Quantity. My workflow will work if all pdf’s are in same format, Otherwise it wont work


#18

issued by silo owner
in respect of silo
on top corner certificate number(3021025)
Date
Quantity
in product description
if there is “X”


#19

@123 try on ur own, Check the process what i did in file. If u got any doubt, let me know i will help you.


#20

I did it i will send u the flow Main.xaml (8