JP7270369B2 - Substitution method, computer program, and information processing system - Google Patents

Description

The present disclosure relates to replacement methods, computer programs, and information processing systems.

A technique for batch replacement of common character strings included in file names of a plurality of data files is already known (see, for example, Japanese Unexamined Patent Application Publication No. 2002-100001). There is also known a technique of comparing a plurality of file names when displaying a plurality of file names, and changing the display form of each file name based on the comparison results (see, for example, Patent Document 2). Techniques for replacing multiple character strings using regular expressions are also known.

JP-A-2000-330842 JP 2009-163561 A

Conventional substitution techniques using regular expressions can be used for various forms of string substitution, but the degree of freedom in writing substitution expressions for string substitution is high, and advanced knowledge is required for substitution. do. That is, in order to work with this technique, the user must learn regular expressions, which are expensive to learn. Furthermore, each time a replacement operation is performed, a plurality of character strings to be replaced must be analyzed and a replacement expression must be manually created so as to produce the desired replacement result.

Although the technique described in Patent Document 1 is excellent in terms of workability, this technique has a low degree of freedom. According to this technology, a user can replace a common character string extracted by a computer with another character string for a plurality of character strings to be replaced. However, other free substitutions cannot be made. Therefore, with the technique described in Patent Document 1, there are many cases in which it is not possible to replace a plurality of character strings so as to produce the desired replacement result for the user.

Therefore, according to one aspect of the present disclosure, it is desirable to provide a technique that allows a user to perform a character string replacement operation with a high degree of freedom more easily than before.

According to one aspect of the present disclosure, a computer-implemented string replacement method is provided. This method includes a step of determining common portions and non-common portions in each of a plurality of processing target character strings on condition that a plurality of processing target character strings are selected through a user interface. A common portion is a character portion that is common among a plurality of character strings to be processed. A non-common part is a character part that is not common among a plurality of character strings to be processed.

The method further includes representing a single string corresponding to a plurality of strings to be processed, wherein the common portion determined by the determining step is represented by the corresponding common character, and the non-common portion is represented by the corresponding code. The step of displaying the single character string on the display is included.

This method further comprises a step of receiving, through a user interface, a change operation for the single character string displayed on the display, and a plurality of processing target character strings based on the change character string, which is the single character string after being changed by the change operation. replacing each with a string that follows the modified string.

According to this replacement method, a change operation with a high degree of freedom can be accepted through a user interface by a change operation on a single character string. According to one example, it is possible to accept an operation to change common characters and an operation to change the order of writing between symbols and common characters.

This modification operation does not require advanced knowledge, unlike conventional replacement techniques using regular expressions. Furthermore, since the analysis of a plurality of character strings to be processed is also realized by a computer, the user does not need to perform the analysis by himself or construct a replacement expression from scratch. The change operation on a single character string generated by the computer corresponding to the replacement expression allows the user to perform replacement work with a high degree of freedom.

Therefore, according to one aspect of the present disclosure, it is possible to provide a technique that allows a user to perform a character string replacement operation with a high degree of freedom more easily than before.

According to one aspect of the present disclosure, the replacement method may include receiving a replacement instruction through a user interface. In the replacing step, on condition that a replacement instruction is input through the user interface, each of the plurality of target character strings can be replaced with a character string conforming to the changed character string.

According to one aspect of the present disclosure, the above replacement method further includes, when the change character string includes an unusable character, a message warning that the unusable character is included before the replacement instruction is input. on a display. According to one aspect of the present disclosure, the above-described replacement method further determines that replacement is not possible before the replacement instruction is input when at least one of the plurality of character strings to be processed is in a non-replaceable state. The method may include causing a message to be displayed on the display to warn that

According to the above warning, it is possible to suppress the waste of some work such as user confirmation work performed before the replacement instruction because the character string cannot be replaced according to the replacement instruction. Therefore, according to one aspect of the present disclosure, it is possible to provide a highly convenient replacement method.

According to one aspect of the present disclosure, the replacement method may further include displaying a plurality of character strings to be processed on a display separately from the single character string.

According to one aspect of the present disclosure, the above replacement method further displays a plurality of processing target character strings on the display separately from the single character string, and furthermore, performs a plurality of processing before the replacement instruction is input. Including a step of controlling the display so that the character string after replacement when the target character string is temporarily replaced based on the changed character string is displayed on the display in place of or in addition to the plurality of processing target character strings. You can This display control allows the user to have an accurate prior understanding of the replacement result.

According to one aspect of the present disclosure, in the step of controlling the display, switching display and non-display of at least one of the plurality of character strings to be processed and the character string after replacement on the display based on a switching instruction through the user interface may control the display.

According to one aspect of the present disclosure, the replacement method further includes assigning a different display form to each of the plurality of codes when the single character string includes a plurality of codes corresponding to the plurality of non-common parts. may contain. The step of causing the display to display the single character string may cause the display to display the single character string including the plurality of codes such that each of the plurality of codes is displayed in an assigned display form. In the step of controlling the display, the plurality of character strings to be processed are displayed on the display such that each non-common portion included in each of the plurality of character strings to be processed is displayed in a display form assigned to the corresponding code. may be displayed.

If a single character string and a plurality of character strings to be processed are displayed in such a manner that the user can identify the corresponding relationship by using different display modes, the workability of the replacement work by the user is improved. Examples of the display form referred to here include a display form defined by display colors. For example, in the assigning step, each of the plurality of codes may be assigned a different color, each of the plurality of codes may be displayed in the assigned color, and each non-common portion may be associated with the corresponding code may be displayed in the color assigned to

According to one aspect of the present disclosure, each of the plurality of character strings to be processed may be a character string representing the name of at least one of individual data files and folders in the file system. By applying the method of the present disclosure to a file system, workability related to name conversion of data files handled by the file system is improved.

According to one aspect of the present disclosure, the multiple character strings to be processed may be character strings in multiple cells in a spreadsheet. By applying the method of the present disclosure to a spreadsheet, workability regarding replacement of character strings handled in the spreadsheet is improved.

According to one aspect of the present disclosure, a computer program for causing a computer to execute the replacement method described above may be provided. A computer readable recording medium storing the computer program may be provided. According to one aspect of the present disclosure, there may be provided an information processing system that executes the replacement method described above.

According to one aspect of the present disclosure, on condition that a plurality of character strings to be processed are selected through a user interface, a determination unit that determines a common portion and a non-common portion in each of a plurality of character strings to be processed; Display on the display a single character string corresponding to the character string to be processed, wherein the common portion determined by the determination unit is represented by the corresponding common character, and the non-common portion is represented by the corresponding code a display control unit that accepts a change operation for a single character string displayed on the display through a user interface; and a replacement processor that replaces each of the strings with a string that follows the modified string. This information processing system has the same effect as the replacement method described above.

1 is a block diagram showing the configuration of an information processing system; FIG. FIG. 10 is an explanatory diagram regarding utilization of a replacement program; 4 is a flowchart showing processing executed by a processor in the first embodiment; FIG. 10 is a diagram showing a first display example of an operation window; FIG. 10 is a diagram showing a second display example of the operation window; FIG. 13 is a diagram showing a third display example of the operation window; It is a figure which shows the first example of a warning display. It is a figure which shows the 2nd example of a warning display. FIG. 10 is an explanatory diagram regarding use of a replacement program in a spreadsheet; It is a flow chart showing processing which a processor performs in a second embodiment.

Exemplary embodiments of the present disclosure are described below in conjunction with the drawings.
[First embodiment]
The information processing system 1 of this embodiment includes a processor 11, a memory 13, a storage device 15, a display 17, and an input device 19, as shown in FIG. This information processing system 1 is configured by, for example, a general-purpose personal computer.

The processor 11 is configured to execute processing according to computer programs stored in the storage device 15 and implement various functions. Memory 13 includes RAM. The storage device 15 functions as an auxiliary storage device for storing various computer programs and data files. Examples of storage devices 15 include solid state drives (SSD) and hard disk drives (HDD).

Computer programs stored in the storage device 15 include, for example, an operating system (OS) such as Windows (registered trademark). The OS provides a file system and a desktop environment that provides a graphical user interface (GUI).

The display 17 is controlled by the processor 11 and configured to display various information for the user. Examples of the display 17 include liquid crystal displays and organic EL displays. The input device 19 is configured to transmit user manipulation signals to the processor 11 . Examples of input devices 19 include keyboards and pointing devices.

Next, the details of the processing that is characteristic of this embodiment will be described. In the information processing system 1, a replacement program for realizing batch replacement of file names is installed via a computer-readable portable recording medium such as a CD-ROM or a memory card, or a wide area network such as the Internet.

The storage device 15 contains multiple data files managed by a file system. These data files include user-generated data files. As is well known, a user can freely assign a file name to a data file created by the user.

A user needs to efficiently replace the file names of these multiple data files collectively. The replacement program stored in the storage device 15 provides excellent functionality for this batch replacement of file names.

By operating the desktop environment through the input device 19, the user selects a plurality of data files to be renamed whose file names are to be replaced collectively, and instructs the execution of the process according to the replacement program. The processing shown can be executed by the processor 11 . Then, through the operation window (see FIG. 4) displayed on the display 17 by this processing, an operation regarding batch replacement of file names can be input.

For example, as shown in FIG. 2, the user selects a plurality of files displayed as icons in the desktop environment using a mouse, and then right-clicks the mouse to display a context menu on the display 17. Then, from the context menu, an item corresponding to a pre-installed replacement program, the item labeled "Replace All" in FIG. 2, can be selected.

By selecting this item, the user can input an instruction to execute processing according to the replacement program to the processor 11 through the input device 19 . Alternatively, the user may input an instruction to execute processing according to the replacement program to the processor 11 through the input device 19 by pressing a pre-assigned shortcut key on the keyboard.

When the processor 11 starts the process shown in FIG. 3 by inputting the execution instruction, it analyzes the current file names of the plurality of rename target data files selected by the user in advance (S110).

In S110, the processor 11 can determine common parts and non-common parts of the file names for each of the plurality of data files to be renamed. The common part here is a character string part that is common among a plurality of data files to be renamed among the character strings forming the file names of the corresponding data files. A non-common part is a character string part that does not correspond to the above-mentioned common part among the character strings forming the file names of the corresponding data files.

For example, a plurality of data files to be renamed include a first data file named "[Staff meeting] Handout materials grade evaluation April 12, 2018.docx", a first data file named "[Linear Algebra] Lecture material matrix is April 01, 2018.pptx", the second data file named "[Calculus] Lecture material sequence and limit April 02, 2018.docx" Consider the case of a total of three data files, including three data files.

In this case, for the first, second, and third data files, the processor 11 determines a plurality of common parts "[", "]", "material", "2018.04", and "day.". Further, the processor 11 distinguishes a plurality of non-common portions "staff meeting", "distribution", "about grade evaluation", "12", and "docx" with respect to the first data file.

Regarding the second data file, the processor 11 discriminates a plurality of non-common portions "linear algebra", "lecture", "what is a matrix", "01", and "pptx", and regarding the third data file, a plurality of non-common portions "differential Discriminate between Integrals, Lectures, Sequences and Limits, 02, and docx.

Some techniques are already known as character string comparison techniques, such as dynamic programming for the longest common subsequence problem. The analysis in S110 can also be realized using or applying such known techniques.

After the analysis in S110, the processor 11 generates a single character string that integrates the file names of the plurality of data files to be renamed, and uses this single character string as the initial value of the replacement expression for each data file to be renamed. The operation window illustrated in FIG. 4 described together with the file name is displayed on the display 17 (S120).

The operation window exemplified in FIG. 4 has an input field for a replacement expression in the upper part and a file name display field for displaying the file names of a plurality of data files to be renamed in the lower part. The above single character string is displayed in the input field as the initial value of the replacement expression. The file name display field displays the current file names of a plurality of data files to be renamed until the replacement expression displayed in the input field is changed from the initial value by the user's operation. After the replacement formula is changed from the initial value, the renamed file names of the plurality of data files to be renamed based on the changed replacement formula are displayed in the file name display column.

As can be understood from FIG. 4, the single character string displayed as the initial value of the replacement expression expresses the common part of the current file names of the multiple data files to be renamed with the corresponding common character, and the non-common part is a string that abstractly represents with the corresponding code.

The single character string shown in FIG. 4 is “[<1>]<2>Document <3>April 4, 2018.<5>”. In this example, the single character string includes "[", "]", "material", "April 2018", and "day." as multiple common characters, and multiple non-common parts as multiple codes. Codes <1>, <2>, <3>, <4>, and <5> are included to distinguish them.

Here, the code <1> is included in the file name of the first data file, "staff meeting", in the file name of the second data file, "linear algebra", and in the file name of the third data file. Corresponds to "calculus".

Similarly, the code <2> corresponds to "distribution", "lecture" and "lecture" included in the file names of the first, second and third data files, and the code <3> corresponds to "grade About evaluation”, “What is a matrix” and “Sequences and limits” correspond to each, code <4> corresponds to each of “12”, “01” and “02”, code <5> corresponds to “docx ” correspond to “pptx” and “docx” respectively.

In S120, the processor 11 assigns different colors to each of the plurality of codes <1><2><3><4><5> according to a predetermined rule, and each code <1><2 included in the single character string. ><3><4><5> are displayed in the corresponding color in the input field, and the non-common part included in the file name of multiple data files to be renamed is displayed in the color assigned to the corresponding code at the bottom. to display the operation window to be displayed on the display 17 .

For example, red is assigned to code <1>, and blue is assigned to code <2>. In this case, the code <1> included in the replacement expression is displayed in red and the code <2> is displayed in blue in the input field of the operation window. Furthermore, at the bottom of the operation window, the text strings "staff meeting", "linear algebra" and "calculus" corresponding to code <1> are displayed in red, and the text string "distribution" corresponding to code <2>. "Lecture" and "Lecture" are displayed in blue.

After displaying the operation window on the display 17, the processor 11 proceeds to S130 and accepts the operation of the operation window through the input device 19 by the user. Then, when an operation is performed, the process corresponding to the operation is executed by the processes of S140 to S190.

At S130, the processor 11 can accept an operation to add a new data file as a rename target. For example, the user can add a new data file to the rename target by dragging and dropping the icon of the data file to be newly added as the rename target to the lower part of the operation window.

When the processor 11 determines that an operation has been performed on the operation window (Yes in S130) and determines that the operation performed is to add a new data file to the rename target (Yes in S140), the process proceeds to S141.

In S141, the processor 11 re-analyzes the file names of all data files to be renamed, including the added data file, and determines common and non-common portions of the file names for each data file. The processor 11 updates the display contents of the operation window on the display 17 based on this determination result (S145).

That is, the processor 11 generates a single character string that integrates and expresses the file names of a plurality of data files to be renamed including the added data file based on the reanalysis result, and uses this single character string as a replacement expression, The display contents of the operation window are updated so as to be displayed on the display 17 together with the file name of each data file to be renamed (S145). After that, the next operation is accepted (S130).

When the processor 11 determines that an operation has been performed on the operation window (Yes at S130), and determines that the operation is a change operation on the replacement expression displayed on the operation window (Yes at S150), the processor 11 proceeds to S155. , update the display contents of the operation window to the contents according to the changed replacement expression.

That is, the processor 11 displays the replacement formula after the change in the input field of the operation window, and displays the file name after replacement of the data file to be renamed according to the replacement formula after the change in the lower part of the operation window. , the display contents of the operation window are updated (S155). The file name after replacement displayed here is the file name when the file name of the "temporarily" corresponding data file is replaced according to the replacement expression after the change. Note that the file name of the data file is not actually changed in S155.

According to the example shown in FIG. 5, the replacement formula is shown in FIG. changed to "(2018-04-<4>)<1>-<3>.<5>". In this case, the character string "(2018-04-12) Staff Meeting-Grading.docx" is displayed for the first data file as the file name after replacement at the bottom of the operation window, and the character string for the second data file is The column "(2018-04-01) Linear Algebra - What is a matrix..pptx" is displayed, and for the third data file the string "(2018-04-02) Calculus - Sequences and Limits.docx" is displayed , the processor 11 updates the display contents of the operation window. After that, the next operation is accepted (S130).

As can be understood from the comparison between FIG. 4 and FIG. 5, in this embodiment, the operations for changing the substitution formula include changing, adding, moving, and deleting common characters, and moving and deleting non-common parts (signs). It can accept delete operations. A "move" operation corresponds to an operation of changing the position of common/non-common characters in the entire character string. This diversity of operations means that the user has a high degree of freedom and can collectively replace the file names of the data files to be renamed by performing operations on replacement expressions.

When the processor 11 determines that an operation has been performed on the operation window (Yes in S130) and determines that the operation performed is an operation to change the display mode (Yes in S160), the process proceeds to S165 and displays the operation window. , to a mode corresponding to the changed display mode. After that, the next operation is accepted (S130).

For example, the user can perform a display mode change operation to switch the display mode between the simple mode and the detailed mode by operating the operation object "option" located at the upper right of the operation window through the input device 19. can be done. The operation windows shown in FIGS. 4 and 5 are operation windows displayed in the simple mode. On the other hand, the operation window shown in FIG. 6 is an operation window displayed in detailed mode.

As can be understood from FIG. 6, in the detailed mode, at the bottom of the operation window, the current file name and the file name after replacement according to the replacement formula are displayed side by side as the file names of the multiple data files to be renamed. be. That is, in the simple mode, when the replacement formula is changed, the file names of the multiple data files to be renamed displayed in the operation window are changed to file names that follow the replacement formula after the change. The file name after substitution according to the expression is displayed in addition to the current file name.

Furthermore, in the detailed mode, first and second input fields are displayed in the upper part of the operation window. The first entry field is the uppermost entry field among the entry fields shown in FIG. 6, and the second entry field is the entry field positioned below the first entry field.
The second input field performs the same function as the simple mode input field. That is, in the second input field, a single character string corresponding to a plurality of data files to be renamed is displayed as the initial value of the replacement expression in a state in which change operations can be accepted.

On the other hand, in the first input field, a character string that integrates and expresses the file names before replacement of the plurality of data files to be renamed is displayed as a pattern expression. The character string initially displayed in the first entry field is the same as the character string initially displayed in the second entry field.

That is, the first input field is a single character string automatically generated based on the file name patterns of the plurality of data files to be renamed analyzed by the processor 11, and is not satisfactory for the user. Sometimes, it is configured to be able to accept modification operations of pattern expressions. In the first input field, the user can also use advanced regular expressions as pattern expressions.

In this way, in the detailed mode, the operation window is displayed so that the user can accept not only the modification operation of the replacement expression but also the modification operation of the underlying pattern expression expression. In addition, in expressions using the symbol <>, making the pattern expression expression and the replacement expression the same indicates that the file name is not changed, but this is not the case when using regular expressions.

In addition, when the processor 11 determines that an operation has been performed on the operation window (Yes at S130), and determines that the operation performed is a cancel operation (Yes at S170), the user's previous operation on the operation window is discarded. Then, the process shown in FIG. 3 ends without executing the file name replacement process for the data file to be renamed. A cancel operation corresponds to, for example, an operation of closing the operation window.

When the processor 11 determines that an operation has been performed on the operation window (Yes at S130) and determines that the performed operation is a replacement instructing operation (Yes at S180), the processor 11 proceeds to S185 and performs replacement processing. Namely, the file names of a plurality of data files to be renamed are replaced with file names according to the replacement formula shown in the operation window. As a result, the file name of each data file to be renamed is actually changed to the file name after replacement displayed in the operation window.

The replacement instruction operation corresponds to the user's pressing operation of the confirm button in the operation window. An operation of pressing a specific key (for example, an enter key) on the keyboard as the input device 19 can also be included as an example of the replacement instruction operation. When a replacement instruction operation is performed, particularly when a specific key is pressed, a dialog box may be displayed on the display 17 asking whether or not the replacement may be executed.

After completing the replacement process, the processor 11 closes the operation window and ends the process shown in FIG. When an operation other than the operation described above is performed, the processor 11 executes processing corresponding to the performed operation (S190). At S190, when the above-described pattern expression expression is modified, the pattern expression expression can be modified and the display of the first input field can be updated in accordance with the operation. The processor 11 then proceeds to S130 and accepts the next operation.

The information processing system 1 of the first embodiment described above analyzes the file names of a plurality of data files to be renamed, displays a single character string that is an integral expression of these as the initial value of the replacement expression, and then replaces Receives the change operation of the expression and performs batch replacement of file names according to the replacement expression after the change.

Therefore, according to the present embodiment, the user does not need to have advanced knowledge when replacing file names, unlike conventional replacement techniques using regular expressions. Furthermore, since the processor 11 also analyzes a plurality of file names to be renamed, the user does not need to perform the analysis by himself or construct a replacement formula from scratch. By changing the replacement expression (single character string) generated by the processor 11, the user can perform replacement work with a high degree of freedom.

Furthermore, in this embodiment, a plurality of non-common parts in the file name of each data file to be renamed displayed in the operation window are displayed in the same color in association with the code in the replacement expression. Therefore, based on the display color, the user can change the replacement formula while having a good understanding of the file name after replacement in advance. Therefore, according to the present embodiment, it is possible to provide a technique that allows a user to perform a character string replacement operation with a high degree of freedom more easily than before.

In addition, when the processor 11 receives an operation to change the substitution formula, it determines whether or not the changed substitution formula contains characters that cannot be used for file names. If characters are included, the display contents of the operation window may be updated so that a warning message such as "Invalid characters are included in the name" is displayed in the operation window (S155). . FIG. 7 shows an exemplary configuration of an operation window containing a warning message "Name contains invalid characters."

In addition, the processor 11 may determine whether or not there is a data file that is used by another process and whose file name cannot be changed, among the plurality of data files to be renamed. good. If the corresponding data file exists, a warning message such as "used by another process" is displayed in the operation window in association with the file name of the corresponding data file, as shown in FIG. Alternatively, the display contents of the operation window may be updated (S120, S145, S155).

Similarly, the processor 11 determines that there is a data file whose file name cannot be changed among the plurality of data files to be renamed because a data file with the same file name as the file name after replacement already exists. It may be determined whether it exists or not. Then, if the corresponding data file exists, a warning message such as "A file with the same name as the file name after replacement exists" may be displayed on the display 17 (S155). For example, the processor 11 displays the message "A file with the same name as the file name after substitution already exists" on the display 17 instead of the message "It is being used by another process" shown in FIG. can be displayed.

The display of such a warning message before the replacement instruction suppresses the possibility that part of the work such as the user's confirmation work performed before the replacement instruction will be wasted because the replacement of the character string according to the replacement instruction cannot be performed. can be done. Therefore, according to the present embodiment, it is possible to provide a highly convenient file name batch replacement function.

According to this embodiment, the replacement program may be configured so that not only data files but also folders can be selected for renaming. A plurality of data files and folders may be mixed as renaming targets. The processor 11 treats the folder name to be renamed in the same manner as the file name, executes the processing shown in FIG. 3, and can collectively replace the folder names according to the replacement formula.

[Second embodiment]
Next, the information processing system 1 of the second embodiment will be described. The second embodiment differs from the first embodiment in that the replacement program is configured for batch replacement of character strings in multiple cells in a spreadsheet, but the hardware configuration of the information processing system 1 is , are the same as in the first embodiment. Therefore, below, the details of the processing executed by the processor 11 according to the replacement program will be described, and the description of the same configuration as the first embodiment will be omitted.

In the second embodiment, when the processor 11 is instructed to execute processing according to the replacement program with a plurality of cells selected in the spreadsheet as shown in FIG. 9 by a user's operation on the spreadsheet, The processing shown in FIG. 10 is executed.

Through the input device 19, the user can instruct the execution of the process according to the replacement program while selecting a plurality of cells for which the character strings are to be replaced collectively as the cells to be processed. Depending on this processing, a GUI-type operation window shown in the lower part of FIG. 9 is displayed on the display 17 . Through this operation window, the user can input operations related to batch replacement of character strings in multiple cells.

For example, as shown in FIG. 9, the user selects a plurality of cells surrounded by dashed lines with the mouse, and then right-clicks the mouse to display the context menu on the display 17, and the context menu is displayed. , you can select the item named "Bulk Replace" that corresponds to the replacement program. By selecting this item, an execution instruction for processing according to the replacement program can be input to the processor 11 through the input device 19 .

When the processor 11 starts the process shown in FIG. 10 by inputting the execution instruction, the processor 11 analyzes the current character strings in the cells selected by the user prior to the execution instruction (S210).

In S210, the processor 11 determines common parts and non-common parts of character strings in each of the plurality of cells to be processed. A common part is a character string part common to a plurality of cells to be processed among the character strings in the corresponding cell. A non-common part is a character string part that does not correspond to the common part among the character strings in the corresponding cell.

For example, as shown in FIG. 9, the plurality of cells to be processed include the first cell having the character string "152 on the 1st floor of Building A", the second cell having the character string "301 on the 3rd floor of Building A", and the character string " Consider the case where there are a total of four cells, including the third cell with the string "131 on the 1st floor of Building B" and the fourth cell with the string "1013 on the 10th floor of the main building".

In this case, for the first, second, third and fourth cells, the processor 11 determines a plurality of common parts "buildings" and "floors". Furthermore, for the first cell, a plurality of non-common portions "A", "1", and "152" are discriminated, and for the second cell, a plurality of non-common portions "A", "3", and "301" are discriminated, For the third cell, a plurality of non-common portions "B", "1", and "131" are determined, and for the fourth cell, a plurality of non-common portions "hon", "10" and "1013" are determined.

After the analysis in S210, the processor 11 generates a single character string "<1> Building <2> Floor <3>" that integrates the character strings in the multiple cells to be processed, and replaces this single character string. The operation window illustrated in the lower part of FIG. 9 described as the initial value of the expression is displayed on the display 17 (S220).

A single character string includes codes <1><2><3> that distinguish and represent each of a plurality of non-common parts. The code <1> corresponds to each of "A issue", "A issue", "B issue", and "book" contained in the character strings in the first, second, third, and fourth cells, and the code <2 > corresponds to each of "1", "3", "1", "10" contained in the character strings in the first, second, third, and fourth cells, and the symbol <3> corresponds to the first, It corresponds to each of "152", "301", "131", and "1013" contained in the character strings in the second, third, and fourth cells.

After displaying the operation window on the display 17, the processor 11 proceeds to S230 and accepts the user's operation on the operation window through the input device 19. FIG. Then, when an operation is performed, the process corresponding to the operation is executed by the processes of S240 to S270.

When the processor 11 determines that an operation has been performed on the operation window (Yes at S230), and determines that the operation has been performed to change the replacement expression displayed on the operation window (Yes at S240), the processor 11 proceeds to S241. , update the display contents of the operation window to the contents according to the changed replacement expression.

Furthermore, in S245, the processor 11 provisionally replaces the character strings in the multiple cells to be processed with the character strings corresponding to the changed replacement formula. Temporary replacement here means that when a cancel instruction is input, the character strings in multiple cells are changed to the character strings corresponding to the replacement formula after the change, in a state where it is possible to return to the initial state before replacement. Corresponds to replace. After that, the next operation is accepted (S230).

When the processor 11 determines that an operation has been performed (Yes in S230), and determines that the performed operation is a cancel operation (Yes in S250), it discards the user's previous operations on the operation window and cancels the operation to be processed. After returning the character strings in the multiple cells to the initial state before replacement (S255), the operation window is closed and the processing shown in FIG. 10 is terminated.

When the processor 11 determines that an operation has been performed (Yes at S230) and determines that the performed operation is a replacement instructing operation (Yes at S260), the processor 11 proceeds to S265, and replaces the cells after provisional replacement in the plurality of cells to be processed. After confirming the character string as the character string after replacement, the operation window is closed and the processing shown in FIG. 10 is terminated.

When an operation other than the above-described operations is performed, the processor 11 executes processing corresponding to the performed operation (S270), shifts to S230, and waits until the next operation is performed.

The information processing system 1 of the second embodiment described above analyzes character strings in multiple cells to be processed, displays a single character string that is integrated and expressed as the initial value of the replacement formula, and then displays the replacement formula accepts the change operation of , and performs batch replacement of strings in multiple cells according to the replacement formula after change. Therefore, according to this embodiment, it is possible to replace character strings in a plurality of cells in a spreadsheet with a high degree of freedom and more easily than before.

It goes without saying that the present disclosure is not limited to the above-described first embodiment and second embodiment, and can take various forms. For example, the character string replacement method implemented by the replacement program of the present disclosure is not limited to batch replacement of file names or batch replacement of character strings in cells.

In the first embodiment, the character string after replacement according to the replacement formula is displayed in advance in the lower part of the operation window, but the character string after replacement does not have to be displayed in advance. In this case, the current file names of the plurality of data files to be renamed may be displayed at the bottom of the operation window, or neither the current file names nor the file names after replacement may be displayed. The processor 11 may perform display control of the operation window so as to switch display and non-display of at least one of the current file name and the file name after replacement according to a switching instruction from the user.

In the first embodiment, a plurality of codes <1><2><3><4><5> and a non-common portion included in the file names of a plurality of data files to be renamed are displayed in different forms. Although the correspondence between the code and the non-common part is clearly displayed to the user by displaying them in different colors, the correspondence may be displayed to the user in other display forms. Differences in appearance can be generated based on differences in at least one of font type, font size, and font color.

A function possessed by one component in the above embodiment may be distributed to a plurality of components. Functions possessed by multiple components may be integrated into one component. A part of the configuration of the above embodiment may be omitted. At least part of the configurations of the above embodiments may be added or replaced with respect to the configurations of other above embodiments. All aspects included in the technical ideas specified by the language in the claims are embodiments of the present disclosure.

DESCRIPTION OF SYMBOLS 1... Information processing system, 11... Processor, 13... Memory, 15... Storage device, 17... Display, 19... Input device.

Claims (10)

A computer-implemented string replacement method comprising:
A common part, which is a character part common among the plurality of character strings to be processed, in each of the plurality of character strings to be processed, on the condition that a plurality of character strings to be processed are selected through a user interface; determining a non-common portion that is a character portion that is not common among the plurality of character strings to be processed;
A single character string corresponding to the plurality of character strings to be processed, wherein the common portion determined by the determining step is represented by a corresponding common character, and the non-common portion is represented by a corresponding code. causing the columns to appear on a display;
receiving, through the user interface , an operation to change the single character string displayed on the display ;
receiving a replacement instruction through the user interface;
On the condition that the replacement instruction is input through the user interface, each of the plurality of processing target character strings is replaced with the changed character string based on the changed character string, which is the single character string after being changed by the change operation. replacing with a string following a column ;
The plurality of character strings to be processed are displayed on the display separately from the single character string, and the plurality of character strings to be processed are temporarily changed to the changed character string before the replacement instruction is input. a step of controlling the display so as to display the character string after replacement when the replacement is performed based on the display instead of or in addition to the plurality of processing target character strings;
when the single character string includes, as the non-common portion, a plurality of codes corresponding to the plurality of non-common portions, assigning a different display form to each of the plurality of codes;
including
causing the display to display the single character string, causing the display to display the single character string including the plurality of codes so as to display each of the plurality of codes in an assigned display form;
The step of controlling the display causes the display to display each of the non-common portions included in each of the plurality of character strings to be processed in a display format assigned to a corresponding code. Replacement method to display the target string . The replacement method of claim 1 , comprising:
The replacement further comprising the step of displaying a warning message on the display to warn that the character string to be changed contains an unusable character before the replacement instruction is entered. Method. A replacement method according to claim 1 or claim 2 ,
When at least one of the plurality of character strings to be processed is in an unreplaceable state, a message warning that the replacement is not possible is displayed on the display before the replacement instruction is input. The permutation method further comprising steps. The replacement method according to any one of claims 1 to 3 ,
In the step of controlling the display, based on a switching instruction through the user interface, switching between display and non-display of at least one of the plurality of character strings to be processed and the character string after replacement on the display is performed. A replacement method that controls the display. The replacement method according to any one of claims 1 to 4 ,
In the assigning step, different colors are assigned as the different display forms to each of the plurality of codes,
each of the plurality of symbols is displayed in an assigned color;
A permutation method in which each of said non-common parts is displayed in the color assigned to the corresponding code. The replacement method according to any one of claims 1 to 5 ,
The replacement method, wherein each of the plurality of character strings to be processed is a character string representing at least one name of an individual data file or folder in the file system. The replacement method according to any one of claims 1 to 6 ,
The replacement method, wherein the plurality of character strings to be processed are character strings in a plurality of cells in a spreadsheet. A computer program for causing a computer to execute the replacement method according to any one of claims 1 to 7 . A common part, which is a character part common among the plurality of character strings to be processed, in each of the plurality of character strings to be processed, on the condition that a plurality of character strings to be processed are selected through a user interface; a determination unit that determines a non-common portion that is a character portion that is not common among the plurality of processing target character strings;
A single character string corresponding to the plurality of character strings to be processed, wherein the common portion determined by the determination unit is represented by a corresponding common character, and the non-common portion is represented by a corresponding code. a first display control unit for displaying on the display;
a first reception unit that receives, through the user interface , a change operation for the single character string displayed on the display ;
a second reception unit that receives a replacement instruction through the user interface;
On the condition that the replacement instruction is input through the user interface, each of the plurality of processing target character strings is replaced with the changed character string based on the changed character string, which is the single character string after being changed by the change operation. a replacement processing unit that replaces with a character string that follows a column;
The plurality of character strings to be processed are displayed on the display separately from the single character string, and the plurality of character strings to be processed are temporarily changed to the changed character string before the replacement instruction is input. a second display control unit that controls the display so that the character string after replacement when the replacement is performed based on the display is displayed on the display instead of or in addition to the plurality of processing target character strings;
when the single character string includes, as the non-common portion, a plurality of codes corresponding to the plurality of non-common portions, an allocation unit that allocates a different display form to each of the plurality of codes;
including
The first display control unit causes the display to display the single character string including the plurality of codes so as to display each of the plurality of codes in the assigned display format,
The second display control unit causes the display to display each of the non-common parts included in each of the plurality of character strings to be processed in a display format assigned to a corresponding code. An information processing system that displays the character string to be processed . The information processing system according to claim 9,
The allocation unit is configured to allocate different colors as the different display forms to each of the plurality of codes,
each of the plurality of symbols is displayed in an assigned color;
An information processing system in which each of the non-common parts is displayed in a color assigned to a corresponding code.

Images