Search found 39 matches

by steve1040
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 ...
by steve1040
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 ...
by steve1040
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 ...
by steve1040
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 ...
by steve1040
Fri Jul 08, 2016 2:07 pm
Forum: General
Topic: Remove everything after string
Replies: 1
Views: 1811

I found the solution

buy-new".*\n
by steve1040
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 ...
by steve1040
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
by steve1040
Fri Jan 16, 2015 4:40 pm
Forum: General
Topic: Add Decimal and remove '
Replies: 2
Views: 2313

Thanks!
That worked fine
by steve1040
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
by steve1040
Thu Aug 21, 2014 3:37 pm
Forum: General
Topic: Replace every 4th line break
Replies: 3
Views: 1688

I think you mean you want to replace every line break except every fourth one with a space. F i nd what: (.*)\n(.*)\n(.*)\n(.*)\n Re p lace with: $1 $2 $3 $4\n [ X ] Regular e xpression Replace A ll Ben I get an error States Cannot match Regular Expression Any idea what I might be doing wrong?
by steve1040
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 ...
by steve1040
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 ...
by steve1040
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

Nevermind I got it

Find: (2010)([[:digit:]]{2})([[:digit:]]{1} )

Replace: \1\20\3

I did something like this for the time also
by steve1040
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 ...
by steve1040
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