The scriptname should have .vbs as extension, the output goes to the file Outfile:
Code:
Dim filesys, Infile, Outfile, pos
Const ForReading = 1, ForWriting = 2
file = InputBox("Filename : ")
if file = "" then
WScript.Quit
end if
Outfile = "Outfile"
Set filesys = CreateObject("Scripting.FileSystemObject")
If NOT filesys.FileExists(file) Then
msgbox("File " & file & " not found!")
WScript.Quit
End If
Set Infile = filesys.OpenTextFile(file, ForReading, True)
Set Outfile = filesys.OpenTextFile(Outfile, ForWriting, True)
do while Infile.AtEndOfStream <> true
Line = Infile.readline
pos = instr(Line,",")
Line = Left(Line, pos - 1) & "|" & Mid(Line, pos + 1)
Outfile.WriteLine(Line)
loop
Infile.Close
Outfile.Close
Set Infile = Nothing
Set Outfile = Nothing
Set filesys = Nothing
MsgBox("Ready")
Can anyone please help with this? I have 2 files as given below.
If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value.
file1
abc_1 foo1@a ....
abc_1 soo2@a ...
def_2 soo2@a ....
def_2 foo1@a ........ (7 Replies)
Hi All, found similar posts, but not exatcly what i wanted.
I have an text file like below and am trying to send mail as an excel file but when i get the excel file as the attachment, all the data is coming in the first column. I need below data in 4 columns.
Unix file
Name,ID,Trade,Date... (3 Replies)
Hello experts,
Please help me in achieving this in an easier way possible. I have 2 csv files with following data:
File1
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012... (5 Replies)
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Dear Team
I need to insert field(which is need to taken from previous line's first field) in first column if its blank. I had tried using sed but not find the way. Detail input and output file as below.
Kindly help for same.
INPUT:
SCGR SC DEV DEV1 NUMDEV DCP ... (7 Replies)
please write a shell script
Table
--------------------------
1 2 3 a b c
3 4 5 c d e
7 8 9 f g h
Output should be like this
---------------
1 2 3
3 4 5
7 8 9
a b c
c d e
f g h (1 Reply)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Hi Experts,
In short : Need to split file when field in column 5 is blank and need to generate two file in which column 5 is blank and other in which column 5 has values along with other rows and column data
My issue is i am not able to get header for column from raw file into new file which... (1 Reply)
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
LEARN ABOUT PHP
strrchr
STRRCHR(3) 1 STRRCHR(3)strrchr - Find the last occurrence of a character in a stringSYNOPSIS
string strrchr (string $haystack, mixed $needle)
DESCRIPTION
This function returns the portion of $haystack which starts at the last occurrence of $needle and goes until the end of $haystack.
PARAMETERS
o $haystack
- The string to search in
o $needle
- If $needle contains more than one character, only the first is used. This behavior is different from that of strstr(3). If
$needle is not a string, it is converted to an integer and applied as the ordinal value of a character.
RETURN VALUES
This function returns the portion of string, or FALSE if $needle is not found.
CHANGELOG
+--------+------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+------------------------------------+
| 4.3.0 | |
| | |
| | This function is now binary safe. |
| | |
+--------+------------------------------------+
EXAMPLES
Example #1
strrchr(3) example
<?php
// get last directory in $PATH
$dir = substr(strrchr($PATH, ":"), 1);
// get everything after last newline
$text = "Line 1
Line 2
Line 3";
$last = substr(strrchr($text, 10), 1 );
?>
NOTES
Note
This function is binary-safe.
SEE ALSO strstr(3), strrpos(3).
PHP Documentation Group STRRCHR(3)