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: 1864

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: 3116

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: 1971

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 ...
by steve1040
Mon Nov 28, 2016 3:57 am
Forum: General
Topic: Insert 2 lines after every 5th occurence of string
Replies: 1
Views: 631

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

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: 1899

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 ...
by steve1040
Wed Sep 30, 2015 9:27 pm
Forum: General
Topic: Combine single field csv into multiple field CSV
Replies: 1
Views: 1997

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: 2763

Thanks!
That worked fine
by steve1040
Fri Jan 16, 2015 1:07 pm
Forum: General
Topic: Add Decimal and remove '
Replies: 2
Views: 2763

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: 1805

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 ...
by steve1040
Tue Aug 19, 2014 7:19 pm
Forum: General
Topic: Replace every 4th line break
Replies: 3
Views: 1805

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 ...
by steve1040
Mon Jan 24, 2011 5:35 pm
Forum: General
Topic: Parse text with ( in it
Replies: 1
Views: 448

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 ...
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: 517

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: 517

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 ...
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: 620

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