Data separated by /n converted to comma delimited?
We're scraping data that looks like this:
NAME=GRANTORS ROWS=10 COLS=30 READONLY>BERRY SARA JR
AMERICAN GENERAL FINANCE CORP
ACCREDITED HOME FINANCE INC
SYSTEMS MORTGAGE REGISTRATION SYSTEMS INC
ACCREDITED CONDO LENDERS INC
We currently have SS setup like this:
NAME=GRANTORS ROWS=10 COLS=30 READONLY>~@NAMES@~
Currently it scraps as one big row but so it's hard to tell where each word starts and stops after it's scraped. Whereas before scraping it's easy to tell with the carriage returns. We want it to have commas separating each values instead, like this:
BERRY SARA JR, AMERICAN GENERAL FINANCE CORP, ACCREDITED HOME FINANCE INC, SYSTEMS MORTGAGE REGISTRATION SYSTEMS INC, ACCREDITED CONDO LENDERS INC
The amount of fields will vary from 2 rows to 20. Is there an easy way to do this you can help me with?
Line breaks in extractor
Line breaks in extractor patterns are dodgy. You might make a script like this, and run it BEFORE the the pattern is applied.
test = test.replaceAll("\\n", "-XXX-");
scrapeableFile.setLastScrapedData(test);
Then instead of line breaks you would have "-XXX-" and would need to make your extractor pattern accordingly.
Perfect! that's exactly what
Perfect! that's exactly what i needed. Thank you.