Acrobat split field into other fields between repeating delimiters

Question

I would like to split up this text into seven fields. There are always seven sections. However the delimeters for each section vary. Don't know if this is too complicated to accomplish with a custom validation script. Thank you in advance!!!:

SECTION1/TEXT HERE SPACES VARY UP UNTIL LAST SPACE SECTION2/TEXT HERE SPACES VARY UP UNTIL LAST SPACE SECTION3/TEXT HERE UP UNTIL END OF LINE NO SPACE

SECTION4/TEXT HERE SPACES VARY UP UNTIL LAST SPACE SECTION5/TEXT HERE UP UNTIL END OF LINE NO SPACE

SECTION6/TEXT HERE SPACES VARY UPUNTIL LAST SPACESECTION7/TEXT HERE UP UNTIL END OF LINE NO SPACE AND NO FURTHER TEXT

Alternative explanation...delimeter pattern (extract each change in color to different field - can be text1, text2, text3, text4, text5, text6, text7):

"/" until last " " of text "/" until last " " of text "/" until end of line no space

"/" until last " " of text "/" until end of line no space

try67 · Accepted Answer

Thank you for the idea. Could I bother you for the script to remove the last four characters of a string, and am a correct in assuming that the script will be placed in the source field "run custom validation script" window, and that the field referenced in the script will be the field receiving the result? Much appreciated.

To remove the last four characters of a string you can use the substring method, like this:

var a = "abcdefghijk";

a = a.substring(0, a.length-4);

// a is now "abcdefg"

As for the location of the code, that depends on what should trigger it. Is this a value that is entered by the user, imported, calculated? Something else?

try67 · Answer

Do you mean you want to extract just the last word before each "/"? If so, split first by "/", then split each one of those strings by " ". Then take the last element in the arrays of the second split commands.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded