Search found 39 matches
- Thu Dec 28, 2017 2:32 pm
- Forum: General
- Topic: XML replace multiple values if XML block contains X
- Replies: 1
- Views: 1770
XML replace multiple values if XML block contains X
I have an xml document with blocks that look like this: <integer name="Activation" value="0"/> <boolean name="CanBuy" value="true"/> <integer name="Cost" value="57600"/> <integer name="CostBuy" value="86400"/> <string name="Country" value="USA"/> <string name="DateBuy" value="01.01.1940"/> <string ...
- Thu Oct 26, 2017 8:58 am
- Forum: General
- Topic: Help convert single column address list into | pipe delimite
- Replies: 3
- Views: 2615
Help convert single column address list into | pipe delimite
I have text formatted like this ********** Errick Smart 8707 West Placestreet Dr Apt 202 Little Rock, AR 72204 501-898-4729 ********** Rev. Leotis James 7210 Miltor Dr North Little Rock, AR 72209 555-123-4823 ********** Rev. Korey Foreman 813 W Nameit St Apt 2 West Memphis, AR 23014 ...
- Thu Oct 05, 2017 4:52 am
- Forum: General
- Topic: Find double digit number on either side of keyword
- Replies: 2
- Views: 1867
Find double digit number on either side of keyword
Row1 = cooperative. he scored 25/30 on the m_m_s_e. language was fluent. he denies Row2 = status, cognition, and cortical functions: m_m_s_e 21/30 · ****** status (including orientation to each row contains the keyword "m_m_s_e" I want to return the 2 digit value that may appear on either side of ...
- Mon Nov 28, 2016 3:57 am
- Forum: General
- Topic: Insert 2 lines after every 5th occurence of string
- Replies: 1
- Views: 423
Insert 2 lines after every 5th occurence of string
I have a text file with 15000 rows (See sample below) How can I insert 2 lines after every 5th instance of the word "ENTER" I need to insert the a new line with the word "ENTER" and a second line with the string "DELAY 35000" Thanks DELAY 5000 CODE: 1234 ENTER DELAY 500 CODE: 0000 ENTER DELAY 500 ...
- Fri Jul 08, 2016 2:07 pm
- Forum: General
- Topic: Remove everything after string
- Replies: 1
- Views: 1811
- Fri Jul 08, 2016 1:20 pm
- Forum: General
- Topic: Remove everything after string
- Replies: 1
- Views: 1811
Remove everything after string
I'm attempting to remove all the text following "=buy-new" I've tried Find =buy-new+$ Replace with =buy-new The find isn't finding the desired text - Please help Thanks What I have /acura/?vehicleclass=newcar&intent=buy-new">Acura</a></li><li><a data-omn-page="buynew_${s.prop2}_make_alfa " /alfa ...
- Wed Sep 30, 2015 9:27 pm
- Forum: General
- Topic: Combine single field csv into multiple field CSV
- Replies: 1
- Views: 1698
Combine single field csv into multiple field CSV
I have data that looks like this (1000 rows)
'AAA',
'ABA',
'BBB',
'ABB',
'BAA'
etc
I need it to look like this
'AAA','ABA','BBB','ABB','BAA' (Combine every 10 line )
When complete I should have 100 rows
Is this possible?
Steve
'AAA',
'ABA',
'BBB',
'ABB',
'BAA'
etc
I need it to look like this
'AAA','ABA','BBB','ABB','BAA' (Combine every 10 line )
When complete I should have 100 rows
Is this possible?
Steve
- Fri Jan 16, 2015 4:40 pm
- Forum: General
- Topic: Add Decimal and remove '
- Replies: 2
- Views: 2313
- Fri Jan 16, 2015 1:07 pm
- Forum: General
- Topic: Add Decimal and remove '
- Replies: 2
- Views: 2313
Add Decimal and remove '
I have 2000+ rows of data that looks like this
'01000'
'01010'
'V4582'
'32729'
'3602'
'0066'
In every row I need to place the last 2 digits behind a decimal and remove the '
Thanks
'01000'
'01010'
'V4582'
'32729'
'3602'
'0066'
In every row I need to place the last 2 digits behind a decimal and remove the '
Thanks
- Thu Aug 21, 2014 3:37 pm
- Forum: General
- Topic: Replace every 4th line break
- Replies: 3
- Views: 1688
- Tue Aug 19, 2014 7:19 pm
- Forum: General
- Topic: Replace every 4th line break
- Replies: 3
- Views: 1688
Replace every 4th line break
I have a file with over 1000 lines Like this CM.ID=1448 OR CM.ID=1740 OR CM.ID=1741 OR CM.ID=1742 OR CM.ID=1744 OR CM.ID=2621 OR CM.ID=2622 OR CM.ID=2623 OR etc I would like the file to look like this CM.ID=1448 OR CM.ID=1740 OR CM.ID=1741 OR CM.ID=1742 OR CM.ID=1744 OR CM.ID=2621 OR CM.ID=2622 OR ...
- Mon Jan 24, 2011 5:35 pm
- Forum: General
- Topic: Parse text with ( in it
- Replies: 1
- Views: 389
Parse text with ( in it
I have several lines of text that look like this: ABS - Title1 (SYS-1121) (Fillable).pdf ( 200 KB ) ABS Something-High Here Orders and MAR (SYS-1122) (Fillable).pdf ( 247 KB ) ACT Low Something Orders and MAR (SYS-1342) (Fillable).pdf ( 254 KB ) MI ThisHere with Something (SYS-1560) (Fillable).pdf ...
- Sat Jan 01, 2011 1:32 pm
- Forum: General
- Topic: How to change date timestamp so it's the same in each line
- Replies: 2
- Views: 401
- Sat Jan 01, 2011 12:53 am
- Forum: General
- Topic: How to change date timestamp so it's the same in each line
- Replies: 2
- Views: 401
How to change date timestamp so it's the same in each line
I have date like this: The field should be YYYYMMDD HH:MM:SS |20100905 23:59:00 |20100905 23:59:00 |20101123 13:05 |20101123 13:05:00 |2010116 10:10 |2010116 10:10 I would like to change the lines that do not have a 2 digit Day or a second So the Data should like this |20100905 23:59:00 |20100905 23 ...
- Wed Dec 29, 2010 8:41 pm
- Forum: General
- Topic: Place term at the beginning of every line or row
- Replies: 1
- Views: 318
Place term at the beginning of every line or row
I need to place the following term at the beginning of each line in my file
STAGEDATA|
I tried
Find: ^
Replace with: ^STAGEDATA|
Didn't change anything
Thanks
Steve
STAGEDATA|
I tried
Find: ^
Replace with: ^STAGEDATA|
Didn't change anything
Thanks
Steve