How can I delete the first row of a CSV file stored in a long Text variable in DS?

Follow

Use a "Convert Variables" step. Please refer to the procedure below.

 

Procedure

1. Add a "Convert Variables" step at the End Step.

2. Click the + button at the bottom of the "Conversions" area.

1.png

 

3. Select a variable that stores a CSV file in "From" of the "Configuration: Conversion" dialog box that appears.

4. Click the + button at the bottom of the "Converters" box and select: Extraction > Extract

2.png

 

5. Enter " .*?\n(.*) " in "Pattern" of the "Configuration: Extraction" dialog box that appears.

 ※To know how to set this area, refer to Kofax RPA Help>Patterns.

  You can also display the Help site with the 31520-5.png button in the Step View.

 

6. Click OK.

3.png

 

7. Select a variable in which to store the value, in "To" of the "Configuration: Conversion" dialog box that reappears.

8. Click OK.

4.png

2 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.