String manipulation after get text action

Help
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

1
11788×684 85.7 KB

2
21907×832 105 KB

3
31894×833 106 KB

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

4
41797×796 91.8 KB

8

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

1 Like
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.

1 Like
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