Questions tagged [delimited]
221 questions
-1
votes
1 answer
Mindboggling Regular Expression to convert Whitespace-Comma-Whitespace input string to an array. Quoting must be supported
Here is my best attempt (so far) to solve this issue. I'm new to regular expressions and this problem is pretty substantial, but I'll give it a try. RegEx's clearly take some time to master.
This seems to satisfy the delimiter/comma requirements. To…
Russ
- 31
- 5
-1
votes
1 answer
Deleting empty fields in pipe delimited printout in perl?
I'm going through each line of a file, looking for a few specific things in each line with regex, and I want to print it so that each row of the output .csv file just contains those things (thing1|thing2|thing3|thing4|) but because it's going…
-2
votes
1 answer
Delimitate Multi Lined Cells in Excel or VBA
Old Prompt
I've been trying to find a method of delimitating cells in Excel using the new line in the text with no luck. I need to delimitate a Cells string into multiple columns separated by the New Lines in the string so now I'm trying to find a…
Christian Prieto
- 73
- 7
-2
votes
2 answers
Nullify fields in pipe delimited file
Am not able to get the desired o/p when the data field has pipe in it.
If the i/p is
SAmple file is tst
hdr1|"hdr2|tst"|"hdr3|tst|tst"|hdr4|"hdr5|tst|tst"
lbl1|"lbl2|tst"|"lbl3|tst|tst"|lbl4|"lbl5|tst|tst"
I tried with this cmd but dont get the…
exp post
- 23
- 2
-2
votes
1 answer
c# sort a tab delimited file
I have seen many subjects on sorting a tab delimited but have been unable to either grasp or comprehend the task to finish this piece of code plus I am just starting in C#. I hope someone can answer this question.
I want to open a text file which is…
Jimmy Boone
- 13
- 4
-2
votes
2 answers
populating a string vector with tab delimited text
I'm very new to C++.
I'm trying to populate a vector with elements from a tab delimited file. What is the easiest way to do that?
Thanks!
Aisha
- 11
- 2
-2
votes
2 answers
Regex, How to extract a delimited string and containing some special words?
From the following html script:
…
hsn_salhi
- 1
- 1
-2
votes
2 answers
Visual Basic Array text file
I'm trying to attach a text file with my data for an array Visual Basic, in Visual Studio 2012.
How do you deliminate new values in the array? I've tried new lines, commas, quotes and it still reads it all as
arrayname(0)
aric8456
- 129
- 2
- 11
-2
votes
4 answers
Access and explode comma-delimited data from multidimensional array then populate a new 2d array
I have a multidimensional array containing comma-separated strings like this
[
[
"users" => [
'email' => 'test@yahoo.com ,testuser@yahoo.com',
'username' => 'test,testuser',
'description' =>…
user3597150
- 31
- 4
-3
votes
1 answer
How to remove all non-numeric characters from the value of nth column of a pipe delimited files in UNIX
I have file in UNIX with many records having pipe delimiter. I want to remove non alpha numeric and non special character from the value of column number 20 which contains phone number and will do right trim 10 digit.
Raj
- 7
- 3
-3
votes
3 answers
Split comma-delimited string of dollar amounts with trailing 3-letter currency into associative array with currency as keys and amount as values
I have string is:
$string = '200AUD, 150USD, 80GBP, 1250000VND';
How Can I convert from $string to an array with key => value.
Key: AUD => Value 200
Key: USD => Value 150
Key: GBP => 80
Key: VND => 1250000
Updated:
@Mark Baker my php version is…
Diep Tang
- 37
- 2
- 11